<!--
  This file is a part of the open-eBackup project.
  This Source Code Form is subject to the terms of the Mozilla Public License, v. 2.0.
  If a copy of the MPL was not distributed with this file, You can obtain one at
  http://mozilla.org/MPL/2.0/.
  
  Copyright (c) [2024] Huawei Technologies Co.,Ltd.
  
  THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
  EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
  MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
  -->


<!DOCTYPE html
  PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html lang="zh-cn" xml:lang="zh-cn">
<head>
      <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
   
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="DC.Type" content="topic">
<meta name="DC.Title" content="步骤9：执行备份">
<meta name="product" content="">
<meta name="DC.Relation" scheme="URI" content="sql-0013.html">
<meta name="prodname" content="">
<meta name="version" content="">
<meta name="brand" content="30-OceanProtect 备份一体机 1.5.0-1.6.0 帮助中心">
<meta name="DC.Publisher" content="20240320">
<meta name="prodname" content="csbs">
<meta name="documenttype" content="usermanual">
<meta name="DC.Format" content="XHTML">
<meta name="DC.Identifier" content="sql-0023">
<meta name="DC.Language" content="zh-cn">
<link rel="stylesheet" type="text/css" href="public_sys-resources/commonltr.css">
<title>步骤9：执行备份</title>
</head>
<body style="clear:both; padding-left:10px; padding-top:5px; padding-right:5px; padding-bottom:5px"><a name="sql-0023"></a><a name="sql-0023"></a>

<h1 class="topictitle1">步骤9：执行备份</h1>
<div><p>执行备份前将需要保护的资源关联到指定SLA，系统将对这些资源按照SLA进行保护，并根据SLA周期性执行备份任务。如需立即执行一次备份任务时，可以通过手动备份实现。</p>
<div class="section"><h4 class="sectiontitle">注意事项</h4><ul><li>手动备份时，SLA中定义的参数（<span class="uicontrol">“<span>失败后自动重试</span>”</span>除外），如<span class="uicontrol">“<span>限速策略</span>”</span>、会应用到手动备份任务中。</li><li>手动备份产生的副本保留时长按照SLA中的定义进行保留。</li></ul>
</div>
<div class="section"><h4 class="sectiontitle">操作步骤</h4><ol><li><span>选择<span class="uicontrol" id="sql-0023__zh-cn_topic_0000001839142377_uicontrol114088356363">“<span id="sql-0023__zh-cn_topic_0000001839142377_text1840913533616">保护</span> &gt; 数据库 &gt; SQL Server”</span>。</span></li><li><span>在<span class="uicontrol">“<span>数据库</span>”</span>页签，选择需要保护的数据库，单击<span class="uicontrol">“<span>保护</span>”</span>。</span><p><p>您也可以勾选多个数据库进行批量保护。</p>
</p></li><li><span>选择用户自行创建的SLA。</span><p><p>您也可以单击<span class="uicontrol">“<span>创建</span>”</span>，创建新的SLA。</p>
<div class="note"><img src="public_sys-resources/note_3.0-zh-cn.png"><span class="notetitle"> </span><div class="notebody"><ul><li>SQL Server不支持使用系统预置的SLA（Gold、Silver、Bronze）。</li><li><span>如果待保护的资源已设置WORM策略，为避免WORM策略冲突，请选择不包含WORM策略的SLA创建保护。</span></li></ul>
</div></div>
</p></li><li><span>参考<a href="#sql-0023__table187795413336">表1</a>，在<span class="uicontrol">“<span>高级配置</span>”</span>中配置参数。</span><p>
<div class="tablenoborder"><a name="sql-0023__table187795413336"></a><a name="table187795413336"></a><table cellpadding="4" cellspacing="0" summary="" id="sql-0023__table187795413336" frame="border" border="1" rules="all"><caption><b>表1 </b>备份高级参数说明</caption><colgroup><col style="width:22.07%"><col style="width:77.92999999999999%"></colgroup><thead align="left"><tr><th align="left" class="cellrowborder" valign="top" width="22.07%" id="mcps1.3.3.2.4.2.1.2.3.1.1"><p>参数</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="77.92999999999999%" id="mcps1.3.3.2.4.2.1.2.3.1.2"><p>说明</p>
</th>
</tr>
</thead>
<tbody><tr><td class="cellrowborder" valign="top" width="22.07%" headers="mcps1.3.3.2.4.2.1.2.3.1.1 "><p><span>备份前执行脚本</span></p>
</td>
<td class="cellrowborder" rowspan="3" valign="top" width="77.92999999999999%" headers="mcps1.3.3.2.4.2.1.2.3.1.2 "><p>您可以根据实际需求，配置“<span>备份前执行脚本</span>”、“<span>备份成功执行脚本</span>”和“<span>备份失败执行脚本</span>”，当备份任务事件中出现“开始执行前置任务”提示后，配置的脚本会在对应场景下执行。</p>
<p><span>请输入脚本名称，脚本名称以</span><strong>.bat</strong><span>结尾。</span><span style="color:#282B33;">请确保脚本已存放在</span><em style="color:#282B33;">安装目录</em><span style="color:#282B33;">\</span>DataBackup\ProtectClient\ProtectClient-E\bin\thirdparty<span style="color:#282B33;">，且登录数据库主机的用户对该脚本有可执行权限。</span></p>
<div class="note"><span class="notetitle"> 说明： </span><div class="notebody"><p><span>当配置了</span><span class="uicontrol">“<span>备份成功执行脚本</span>”</span><span>时，即使该脚本执行失败，管理界面上也会显示备份任务的状态为</span><span class="uicontrol">“<span>成功</span>”</span><span>。请您留意任务详情中是否有后置脚本执行失败的相关提示，如有请及时修正脚本。</span></p>
</div></div>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" headers="mcps1.3.3.2.4.2.1.2.3.1.1 "><p><span>备份成功执行脚本</span></p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" headers="mcps1.3.3.2.4.2.1.2.3.1.1 "><p><span>备份失败执行脚本</span></p>
</td>
</tr>
</tbody>
</table>
</div>
</p></li><li><span>单击<span class="uicontrol" id="sql-0023__zh-cn_topic_0000001964713008_zh-cn_topic_0000001656691397_uicontrol471113581111">“确定”</span>。</span><p><p id="sql-0023__zh-cn_topic_0000001964713008_zh-cn_topic_0000001656691397_p25041111535">如果当前系统时间已晚于SLA首次备份的开始时间，可以在弹出的对话框中选择立即执行手动备份或者根据SLA中设置的备份策略周期性自动执行备份。</p>
</p></li><li><span>执行手动备份。</span><p><p>当需要立即执行一次备份任务时，可以执行以下操作进行手动备份。否则，可跳过本步骤。</p>
<ol type="a"><li>在需要备份的数据库所在行单击<span class="uicontrol">“<span>更多</span> &gt; <span>手动备份</span>”</span>。<div class="note"><img src="public_sys-resources/note_3.0-zh-cn.png"><span class="notetitle"> </span><div class="notebody"><p>支持选择多个资源批量进行手动备份。勾选多个资源，在页面左上角选择<span class="uicontrol">“<span>更多</span> &gt; <span>手动备份</span>”</span>。</p>
</div></div>
</li><li>设置手动备份产生的副本名称。<p>如果您不设置，系统默认设置副本名称为：backup_时间戳。</p>
</li><li>选择保护策略：<span>全量备份</span>、<span>差异备份</span>或<span>日志备份</span>。<div class="note"><img src="public_sys-resources/note_3.0-zh-cn.png"><span class="notetitle"> </span><div class="notebody"><p><span id="sql-0023__zh-cn_topic_0000001964713008_ph19374310343">对于1.6.0及后续版本，如果选择的保护策略与关联的SLA中配置的保护策略不一致，则WORM配置不生效。</span></p>
</div></div>
</li><li>单击<span class="uicontrol">“确定”</span>。</li></ol>
</p></li></ol>
</div>
<p></p>
</div>
<div>
<div class="familylinks">
<div class="parentlink"><strong>父主题：</strong> <a href="sql-0013.html">备份SQL Server数据库</a></div>
</div>
</div>

<div class="hrcopyright"><hr size="2"></div><div class="hwcopyright">版权所有 &copy; 华为技术有限公司</div></body>
</html>